<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML" 4.01"//EN" "http://www.w3.org/TR/html4/strict.dtd">
<!-- Created: June 18, 2002-->
<!--
$Id$
$Header$
$Log$
-->

<html>
<head>
<title>Radiological Euipment Databae</title>
<link rev="made" href="mailto:eugenem@ix.netcom.com">
<link rev="home" href="http://home.netcom.com/~eugenem/">
<meta name="author" content="Eugene Mah">
<meta name="description" content="">
<meta name="Keywords" content="">
<meta name="Reply-to" content="eugenem@ix.netcom.com">
<meta http-equiv="Content-Script-Type" content="text/javascript">
<META http-equiv="PICS-Label" content='(PICS-1.1 "http://www.classify.org/safesurf/" l r (SS~~0001))'>
<?PHP
require('functions.inc');
require('dbc.inc');
?>
</head>

<body>
<h1>Radiological Equipment Database</h1>
<!--
This form is used to select a survey ID to add fluoroscopy exposure
data to.

The user is asked to select from the list of survey IDs and paste
the fluoro skin entrance exposure data into the text area.

Data is copied from the Excel spreadsheet block and pasted
directly into the textarea.
-->
<?PHP
/*
  Select the SurveyIDs from TestDates that aren't already in the
   table.
*/
$query = "SELECT TestDates.SurveyID from TestDates LEFT JOIN GenData ";
$query .= "ON TestDates.SurveyID=GenData.SurveyID ";
$query .= "WHERE GenData.SurveyID IS NULL";

$survID = mysql_query("select SurveyID from TestDates");
echo listbox_one_field($survID,"SurveyID","");
?>
<form name="FLData" action="<?PHP echo $SERVER['PHP_SELF']; ?>" method="POST">

</form>
</body>
</html>
